prepare("SELECT * FROM students WHERE id = ?");
$stmt->execute([$_SESSION['student_id']]);
$student = $stmt->fetch(PDO::FETCH_ASSOC);
// Get available exams
$stmt = $pdo->prepare("
SELECT e.*, s.name as subject_name
FROM exams e
LEFT JOIN subjects s ON e.subject_id = s.id
WHERE e.status = 'active'
ORDER BY e.year DESC, e.name
");
$stmt->execute();
$exams = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Get recent results
$stmt = $pdo->prepare("
SELECT r.*, e.name as exam_name, e.year
FROM results r
JOIN exam_sessions es ON r.session_id = es.id
JOIN exams e ON es.exam_id = e.id
WHERE es.student_id = ?
ORDER BY r.submitted_at DESC
LIMIT 5
");
$stmt->execute([$_SESSION['student_id']]);
$recent_results = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
Student Dashboard - MMGSS NNEWI CBT